﻿IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'ssp_Help_get')
                    AND type IN ( N'P', N'PC' ) ) 
    DROP PROCEDURE ssp_Help_get
GO

SET   QUOTED_IDENTIFIER   ON
go
CREATE procedure ssp_Help_get
(
    @MenuID int,
	@HelpID int
)
as

BEGIN
	IF @HelpID > 0
		SELECT * FROM TS_Help WHERE HelpID = @HelpID
	ELSE
		SELECT * FROM TS_Help WHERE MenuID = @MenuID ORDER BY HelpOrder

END  
